from ..pymysql.tools.dbutil import DBUtil


def build_data():
    sql = "select * from t_login"
    db_data = DBUtil.exe_sql(sql)
    print(db_data)

    test_data = []
    for case_data in db_data:
        username = case_data[2]
        password = case_data[3]
        verify_code = case_data[4]
        status_code = case_data[5]
        content_type = case_data[6]
        status = case_data[7]
        msg = case_data[8]
    test_data.append((username, password, verify_code, status_code, content_type, status, msg))
    print("test_data = {}".format((username, password, verify_code, status_code, content_type, status, msg)))
    return test_data

